{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Mastersheet ","LETSDOIT","Accounting 1 ","Law","Costing","Taxation ","Accounting 2 ","Auditing ","IT & SM","FM ","Sheet10"],"not_rendered":{"charts":1,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mastersheet ","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Completion","More to Go"]
["Accounting ",{"$f":"Sheet10!M34","v":0},{"$f":"100%-B3","v":1},{"$f":"IF(B3>=70%, \"Well DONE\",\"DON’T GIVEUP\")","v":"DON’T GIVEUP"}]
["Law",{"$f":"Sheet10!W17","v":0},{"$f":"100%-B4","v":1},{"$f":"IF(B4>=70%, \"Well DONE\",\"DON’T GIVEUP\")","v":"DON’T GIVEUP"}]
["Costing ",{"$f":"Sheet10!M56","v":0.11333333333333333},0.88666666666666671,"DON’T GIVEUP"]
["Taxation ",{"$f":"Sheet10!W62","v":0},1,"DON’T GIVEUP"]
[]
["Accounting 2 ",{"$f":"Sheet10!M89","v":1.1538461538461539E-2},{"$f":"100%-B8","v":0.9884615384615385},{"$f":"IF(B8>=70%, \"Well DONE\",\"DON’T GIVEUP\")","v":"DON’T GIVEUP"}]
["Auditing ",{"$f":"Sheet10!W80","v":0},{"$f":"100%-B9","v":1},"DON’T GIVEUP"]
["IT and SM",{"$f":"Sheet10!M109","v":0},{"$f":"100%-B10","v":1},"DON’T GIVEUP"]
["FM",{"$f":"Sheet10!Y111","v":0},{"$f":"100%-B11","v":1},"DON’T GIVEUP"]
{"$rows_empty":29}
[{"$nulls":12},"`"]

{"sheet":"LETSDOIT","index":1,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":29}
["Accounting ",{"$f":"'Mastersheet '!D3","v":"DON’T GIVEUP"}]
["Law",{"$f":"'Mastersheet '!D4","v":"DON’T GIVEUP"}]
["Costing ",{"$f":"'Mastersheet '!D5","v":"DON’T GIVEUP"}]
["Taxation ",{"$f":"'Mastersheet '!D6","v":"DON’T GIVEUP"}]
[]
["Accounting 2 ",{"$f":"'Mastersheet '!D8","v":"DON’T GIVEUP"}]
["Auditing ",{"$f":"'Mastersheet '!D9","v":"DON’T GIVEUP"}]
["IT and SM",{"$f":"'Mastersheet '!D10","v":"DON’T GIVEUP"}]
["FM",{"$f":"'Mastersheet '!D11","v":"DON’T GIVEUP"}]

{"sheet":"Accounting 1 ","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,8,27,8],[1,9,27,9],[1,10,27,10],[22,0,24,0],[1,2,12,2],[13,2,18,2],[19,2,24,2],[25,2,26,2],[0,0,0,1],[25,0,25,1],[26,0,26,1],[19,0,21,0],[13,0,18,0]]}
["Introduction to Accounting Standards",null,"Marks allocation (Maximum)","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[1,"Disclosure of Accounting Policies",0.25,null,1]
[2,"Valuation of Inventories",null,null,1]
[3,"Cash Flow Statements",null,null,5]
[4,"Contingencies and Events occurring after the Balance Sheet Date",null,null,1]
[5," Net Profit or Loss for the Period, Prior Period Items and Changes in Accounting Policies ",null,null,2]
[10,"Property, Plant and Equipment",null,null,2]
[11,"The Effects of Changes in Foreign Exchange Rates ",null,null,3]
[12,"Accounting for Government Grants",null,null,2]
[13,"Accounting for Investments",null,null,3]
[16,"Borrowing Costs ",null,null,1]
[17,"Segment Reporting",null,null,1]
[22," Accounting for Taxes on Income ",null,null,3]
["Company Accounts ","Preparation of financial statements – Statement of Profit and Loss, Balance Sheet and Cash Flow Statement ",0.3,null,2]
[null,"Managerial Remuneration ",null,null,3]
[null,"Profit (Loss) prior to incorporation ",null,null,3]
[null,"Accounting for bonus issue and right issue ",null,null,3]
[null,"Redemption of preference shares ",null,null,3]
[null,"Redemption of debentures ",null,null,4]
["Accounting for Special Transactions ","Investment ",0.35,null,5]
[null,"Insurance claims for loss of stock and loss of profit ",null,null,2]
[null,"Hire- purchase and Instalment sale transactions ",null,null,5]
[" Special Type of Accounting ","Departmental Accounting ",null,null,4]
[null,"Accounting for Branches including foreign branches ",null,null,7]
[null,"Accounts from Incomplete Records ",null,null,5]
["DISSOLUTION OF PARTNERSHIP FIRMS ",null,0.2,null,10]
["AMALGAMATION, CONVERSION AND SALE OF PARTNERSHIP FIRMS ",null,null,null,10]
[]
[null,null,"Total",null,91,null,null,null,{"$f":"SUM(I2)","v":0},{"$f":"SUM(J2)","v":0},0]
[{"$nulls":5},{"$f":"IF(F2=\"Completed \",1,0)","v":0}]

{"sheet":"Law","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,9,17,9],[2,10,17,10],[2,8,17,8],[2,2,5,2],[6,2,8,2],[9,2,11,2]]}
["Introduction to Accounting Standards",null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,"The Companies Act, 2013- Section 1 to 148 "]
[null,"1. Preliminary",0.4,null,5]
[null,"2. Incorporation of company and matters incidental thereto ",null,null,4]
[null,"3. Prospectus and Allotment of securities",null,null,4]
[null,"4. Share capital and Debentures ",null,null,4]
[null,"5. Acceptance of Deposits by companies",0.3,null,3]
[null,"6. Registration of Charges",null,null,5]
[null,"7. Management and Administration ",null,null,3]
[null,"8. Declaration and payment of dividend",0.3,null,4]
[null," 9. Accounts of companies",null,null,6]
[null,"10. Audit and auditors ",null,null,4]
[null,"Part II - Other Laws (40 Marks) ",null,null,3]
[null,"1. The Indian Contract Act, 1872 ",0.35,null,9]
[null,"2. The Negotiable Instruments Act, 1881: ",0.35,null,13]
[null,"3. The General Clauses Act, 1897: ",0.25,null,7]
[null,"4. Interpretation of statutes: ",0.25,null,5]
[null,null,"Total",null,{"$f":"SUM(E2:E17)","v":79}]
[{"$nulls":8},{"$f":"SUM(I3)","v":0},{"$f":"SUM(J3)","v":0},0]

{"sheet":"Costing","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,8,15,8],[1,9,15,9],[1,10,15,10],[2,2,7,2],[8,2,11,2],[12,2,14,2]]}
[null,null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,"Introduction to Cost and Management Accounting ",0.15,"EASY ",4,"Completed ","Completed ","Completed ",45]
[null,"Elements of Cost and preparation of Cost Sheets ",0.4,null,3]
[null,"Material Cost ",null,null,5]
[null,"Employee Cost ",null,null,7]
[null,"Overheads ",null,null,6]
[null,"Concepts of Activity Based Costing (ABC) ",null,null,2]
[null,"Recording and Accounting of Costs ",null,null,3]
[null,"Job Costing and Batch Costing ",0.3,null,2]
[null,"Contract Costing ",null,null,5]
[null,"Process/ Operation Costing ",null,null,8]
[null,"Costing of Service Sectors ",null,null,6]
[null,"Standard Costing ",0.25,null,7]
[null,"Marginal Costing ",null,null,7]
[null,"Budget and Budgetary Control ",null,null,5]
[null,null,"Total",null,{"$f":"SUM(E2:E15)","v":70}]
[{"$nulls":8},{"$f":"SUM(I2)","v":45},{"$f":"SUM(J2)","v":0},0]

{"sheet":"Taxation ","index":5,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,2,21,2],[0,0,0,1],[1,8,22,8],[1,9,22,9],[1,10,22,10],[3,2,4,2],[5,2,7,2],[9,2,11,2],[12,2,13,2],[14,2,16,2]]}
["Taxation ",null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,"Basic Concepts ",0.1,null,4]
[null,"Residential status and scope of total income ",0.1,null,4]
[null,"Incomes which do not form part of total income ",0.2,null,5]
[null,"Heads of income and the provisions governing computation of income under different heads ",null,null,18]
[null,"Income of other persons included in assessee's total income ",0.12,null,4]
[null,"Aggregation of income; Set-off, or carry forward and set-off of losses ",null,null,3]
[null,"Deductions from gross total income ",null,null,4]
[null,"Computation of total income and tax liability of individuals ",0.15,null,6]
[null,"Advance tax, tax deduction at source ",0.15,null,3]
[null,"Introduction to tax collection at source ",null,null,2]
[null,"Provisions for filing return of income and self-assessment ",null,null,3]
[null,"Concept of indirect taxes - Concept and features of indirect taxes; Principal indirect taxes ",0.05,null,2]
[null,"GST Laws: An introduction including Constitutional aspects ",null,null,2]
[null,"Levy and collection of CGST and IGST ",0.25,null,6]
[null,"Basic concepts of time and value of supply ",null,null,5]
[null,"Input tax credit ",null,null,4]
[null,"Computation of GST liability ",0.1,null,5]
[null,"Registration ",0.15,null,3]
[null,"Tax invoice; Credit and Debit Notes; Electronic way bill ",null,null,3]
[null,"Returns ",null,null,3]
[null,"Payment of tax ",null,null,3]
[null,null,"Total",null,{"$f":"SUM(E2:E22)","v":92}]
[{"$nulls":5},{"$f":"IF(F2=\"Completed \",1,0)","v":0},null,null,{"$f":"SUM(I2)","v":0},{"$f":"SUM(J2)","v":0},0]

{"sheet":"Accounting 2 ","index":6,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,2,21,2],[1,8,22,8],[1,10,22,10],[1,9,22,9],[0,0,0,1],[1,2,9,2],[10,0,15,0],[10,2,15,2],[16,0,19,0],[16,2,19,2]]}
["Application of Accounting Standards",null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[7,"Construction Contracts ",0.25,null,2]
[9,"Revenue Recognition ",null,null,2]
[14,"Accounting for Amalgamations ",null,null,4]
[18,"Related Party Disclosures ",null,null,2]
[19,"Leases ",null,null,2]
[20,"Earnings Per Share ",null,null,2]
[24,"Discontinuing Operations ",null,null,2]
[26,"Intangible Assets ",null,null,2]
[29,"Provisions, Contingent Liabilities and Contingent Assets ",null,null,2]
["Company Accounts ","ESOP",0.4,null,4]
[null,"Buy Back",null,null,5,"Completed ","Completed ","Completed "]
[null,"Equity with Differential Rights ",null,null,2]
[null,"Underwriting ",null,null,4]
[null,"Amalgamation ",null,null,10]
[null,"Liqudation",null,null,6]
["Accounting for Special Transactions ","Insurance companies ",0.35,null,5]
[null,"Banking companies ",null,null,5]
[null,"Non-Banking Financial Companies; ",null,null,4]
[null,"Mutual funds ",null,null,4]
[null,"Valuation of goodwill ",0.25,null,5]
[null,"Consolidated Financial Statements ",null,null,14]
[]
[null,null,"Total",null,{"$f":"SUM(E2:E23)","v":88},null,null,null,{"$f":"I2","v":0},{"$f":"J2","v":0},0]
[{"$nulls":5},1]

{"sheet":"Auditing ","index":7,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,9,14,9],[1,10,14,10],[1,2,4,2],[6,2,7,2],[8,2,9,2],[12,2,13,2],[1,8,14,8]]}
["Standards - Compulosry",null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,"Nature, Objective and Scope of Audit ",0.25,null,7]
[null,"Audit Strategy, Audit Planning and Audit Programme ",null,null,4]
[null,"Audit Sampling ",null,null,3]
[null,"Analytical Procedures ",null,null,4]
[null,"Audit Documentation and Audit Evidence ",0.15,null,11]
[null,"Risk Assessment and Internal Control ",0.15,null,6]
[null,"Audit in an Automated Environment: ",null,null,4]
[null,"Fraud and Responsibilities of the Auditor in this Regard ",0.2,null,5]
[null,"The Company Audit ",null,null,5]
[null,"Audit Report ",0.15,null,6]
[null,"Audit of Items of Financial Statements ",0.15,null,6]
[null,"Audit of Banks ",0.2,null,4]
[null,"Audit of Different Types of Entities ",null,null,5]
[null,null,"Total",null,{"$f":"SUM(E2:E14)","v":70}]
[{"$nulls":5},{"$f":"IF(F2=\"Completed \",1,0)","v":0},null,null,{"$f":"SUM(I2)","v":0},{"$f":"SUM(J2)","v":0},0]
[]
["Important Standards"]
["SQC 1 "]
["SA 200 "]
["SA 210 "]
["SA 220 "]
["SA 300"]
["SA 320 "]
["SA 530 "]
["SA 520 "]
["SA 230 "]
["SA 500 "]
["SA 580 "]
["SA 501 "]
["SA 505 "]
["SA 510 "]
["SA 550 "]
["SA 560 "]
["SA 570 "]
["SA 315 "]
["SA 320 "]

{"sheet":"IT & SM","index":8,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,10,14,10],[1,0,5,0],[6,0,13,0],[0,0,0,1],[1,8,14,8],[1,9,14,9]]}
[null,null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
["Enterprise Information Systems ","Automated Business Processes ",0.12,null,6]
[null,"Financial and Accounting Systems ",0.12,null,6]
[null,"Information Systems and its Components ",0.12,null,5]
[null,"E-Commerce, M-Commerce and Emerging Technologies ",0.12,null,5]
[null,"Core Banking Systems ",0.12,null,6]
["Strategic Management ","Introduction to Strategic Management ",0.12,null,5]
[null,"Dynamics of Competitive Strategy ",0.08,null,4]
[null,"Strategy Management Process ",0.08,null,4]
[null,"Corporate Level Strategies",0.08,null,4]
[null,"Business Level Strategies",0.08,null,4]
[null,"Functional Level Strategies ",0.08,null,4]
[null,"Organisation and Strategic Leadership ",0.08,null,4]
[null,"Strategy Implementation and Control ",0.08,null,4]
[null,null,"Total",null,{"$f":"SUM(E2:E14)","v":61}]
[{"$nulls":5},1,null,null,{"$f":"SUM(I2)","v":0},{"$f":"SUM(J2)","v":0},0]

{"sheet":"FM ","index":9,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,8,15,8],[0,0,0,1],[1,9,15,9],[1,10,15,10],[1,0,11,0],[12,0,15,0],[1,2,2,2],[3,2,7,2],[8,2,10,2]]}
[null,null,"Marks allocation ","Difficulty Level","No of Hours ","Theory ","Questions from Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
["Financial Management ","Introduction to Financial Management Function ",0.1,null,4]
[null,"Financial Analysis through Ratios ",null,null,5]
[null,"Sources of Finance ",0.27,null,4]
[null,"Lease Financing ",null,null,6]
[null,"Cost of Capital ",null,null,6]
[null,"Capital Structure Decisions ",null,null,7]
[null,"Leverages ",null,null,5]
[null,"Capital Investment Decisions ",0.21,null,6]
[null,"Adjustment of Risk and Uncertainty in Capital Budgeting Decision ",null,null,5]
[null,"Dividend Decisions ",null,null,6]
[null,"Management of Working Capital ",0.09,null,6]
["Economics for Finance ","Determination of National Income ",0.12,null,3]
[null,"Public Finance ",0.12,null,3]
[null,"The Money Market ",0.12,null,3]
[null,"International Trade ",0.12,null,3]
[null,null,"Total",null,{"$f":"SUM(E2:E16)","v":72},null,null,null,{"$f":"I2","v":0},{"$f":"J2","v":0},0]
[{"$nulls":5},{"$f":"IF(F2=\"Completed \",1,0)","v":0}]

{"sheet":"Sheet10","index":10,"n_rows":112,"n_cols":25,"rows_kept":112,"cut":false,"hidden":true,"merged":[[93,1,93,2],[93,13,93,14],[14,1,19,1],[20,1,22,1],[24,1,24,2],[28,1,28,2],[29,1,29,2],[2,17,14,17],[2,18,14,18],[64,1,64,2],[65,6,86,6],[65,7,86,7],[65,8,86,8],[64,11,64,12],[39,6,53,6],[39,7,53,7],[39,8,53,8],[1,11,1,12],[2,16,14,16],[38,1,38,2],[38,11,38,12],[2,6,31,6],[2,7,31,7],[2,8,31,8]]}
["Rate "]
["EASY ",null,"Accounting ","Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap","Law",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
["MEDIUM",1,"Disclosure of Accounting Policies",{"$f":"IF('Accounting 1 '!F2=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G2=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H2=\"Completed \",0.5,0)","v":0},{"$f":"'Accounting 1 '!I29","v":0},{"$f":"'Accounting 1 '!J29","v":0},{"$f":"'Accounting 1 '!K29","v":0},{"$f":"IF('Accounting 1 '!L2=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M2=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F3=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G3=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H3=\"Completed \",1,0)","v":0},{"$f":"Law!I19","v":0},{"$f":"Law!J19","v":0},{"$f":"Law!K19","v":0},{"$f":"IF(Law!L3=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M3=\"Completed \",1,0)","v":0}]
["DIFFICULT",2,"Valuation of Inventories",{"$f":"IF('Accounting 1 '!F3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M3=\"Completed \",1,0)","v":0},null,null,{"$f":"IF(Law!F4=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G4=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L4=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M4=\"Completed \",1,0)","v":0}]
[null,3,"Cash Flow Statements",{"$f":"IF('Accounting 1 '!F4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M4=\"Completed \",1,0)","v":0},null,null,{"$f":"IF(Law!F5=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G5=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L5=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M5=\"Completed \",1,0)","v":0}]
["Lets do it",4,"Contingencies and Events occurring after the Balance Sheet Date",{"$f":"IF('Accounting 1 '!F5=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G5=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H5=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L5=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M5=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F6=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G6=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L6=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M6=\"Completed \",1,0)","v":0}]
["Completed ",5," Net Profit or Loss for the Period, Prior Period Items and Changes in Accounting Policies ",{"$f":"IF('Accounting 1 '!F6=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G6=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H6=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L6=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M6=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F7=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G7=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L7=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M7=\"Completed \",1,0)","v":0}]
["Pending ",10,"Property, Plant and Equipment",{"$f":"IF('Accounting 1 '!F7=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G7=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H7=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L7=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M7=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F8=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G8=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L8=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M8=\"Completed \",1,0)","v":0}]
[null,11,"The Effects of Changes in Foreign Exchange Rates ",{"$f":"IF('Accounting 1 '!F8=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G8=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H8=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L8=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M8=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F9=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G9=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L9=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M9=\"Completed \",1,0)","v":0}]
[null,12,"Accounting for Government Grants",{"$f":"IF('Accounting 1 '!F9=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G9=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H9=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L9=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M9=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F10=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G10=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L10=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M10=\"Completed \",1,0)","v":0}]
[null,13,"Accounting for Investments",{"$f":"IF('Accounting 1 '!F10=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G10=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H10=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L10=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M10=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F11=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G11=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L11=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M11=\"Completed \",1,0)","v":0}]
[null,16,"Borrowing Costs ",{"$f":"IF('Accounting 1 '!F11=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G11=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H11=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L11=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M11=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F12=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G12=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L12=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M12=\"Completed \",1,0)","v":0}]
[null,17,"Segment Reporting",{"$f":"IF('Accounting 1 '!F12=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G12=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H12=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L12=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M12=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F13=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G13=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L13=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M13=\"Completed \",1,0)","v":0}]
[null,22," Accounting for Taxes on Income ",{"$f":"IF('Accounting 1 '!F13=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!G13=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!H13=\"Completed \",0.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L13=\"Completed \",0.5,0)","v":0},{"$f":"IF('Accounting 1 '!M13=\"Completed \",0.5,0)","v":0},null,null,{"$f":"IF(Law!F14=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G14=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L14=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M14=\"Completed \",1,0)","v":0}]
[null,"Company Accounts ","Preparation of financial statements – Statement of Profit and Loss, Balance Sheet and Cash Flow Statement ",{"$f":"IF('Accounting 1 '!F14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M14=\"Completed \",1,0)","v":0},null,null,{"$f":"IF(Law!F15=\"Completed \",1,0)","v":0},{"$f":"IF(Law!G15=\"Completed \",1,0)","v":0},{"$f":"IF(Law!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Law!L15=\"Completed \",1,0)","v":0},{"$f":"IF(Law!M15=\"Completed \",1,0)","v":0}]
[null,null,"Managerial Remuneration ",{"$f":"IF('Accounting 1 '!F15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M15=\"Completed \",1,0)","v":0},null,null,{"$f":"SUM(N3:N15)","v":0},{"$f":"SUM(O3:O15)","v":0},{"$f":"SUM(P3:P15)","v":0},{"$f":"SUM(Q3:Q15)/2","v":0},{"$f":"SUM(R3:R15)/2","v":0},{"$f":"SUM(S3:S15)/2","v":0},{"$f":"SUM(T3:T15)","v":0},{"$f":"SUM(U3:U15)","v":0},null,215]
[null,null,"Profit (Loss) prior to incorporation ",{"$f":"IF('Accounting 1 '!F16=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G16=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H16=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L16=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M16=\"Completed \",1.5,0)","v":0},null,null,{"$f":"N16*1","v":0},{"$f":"O16*1","v":0},0,0,0,0,0,0,{"$f":"SUM(N17:U17)","v":0},{"$f":"V17/W16","v":0}]
[null,null,"Accounting for bonus issue and right issue ",{"$f":"IF('Accounting 1 '!F17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H17=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M17=\"Completed \",1,0)","v":0},null,"Weightage"]
[null,null,"Redemption of preference shares ",{"$f":"IF('Accounting 1 '!F18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H18=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M18=\"Completed \",1,0)","v":0}]
[null,null,"Redemption of debentures ",{"$f":"IF('Accounting 1 '!F19=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G19=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H19=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L19=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M19=\"Completed \",1.5,0)","v":0}]
[null,"Accounting for Special Transactions ","Investment ",{"$f":"IF('Accounting 1 '!F20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H20=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M20=\"Completed \",1,0)","v":0}]
[null,null,"Insurance claims for loss of stock and loss of profit ",{"$f":"IF('Accounting 1 '!F21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H21=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M21=\"Completed \",1,0)","v":0}]
[null,null,"Hire- purchase and Instalment sale transactions ",{"$f":"IF('Accounting 1 '!F22=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G22=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H22=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L22=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M22=\"Completed \",1.5,0)","v":0}]
[]
[null," Special Type of Accounting "]
[null,null,"Departmental Accounting ",{"$f":"IF('Accounting 1 '!F23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H23=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M23=\"Completed \",1,0)","v":0}]
[null,null,"Accounting for Branches including foreign branches ",{"$f":"IF('Accounting 1 '!F24=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G24=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H24=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L24=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M24=\"Completed \",1.5,0)","v":0}]
[null,null,"Accounts from Incomplete Records ",{"$f":"IF('Accounting 1 '!F25=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!G25=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!H25=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L25=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 1 '!M25=\"Completed \",1,0)","v":0}]
[null,"DISSOLUTION OF PARTNERSHIP FIRMS ",null,{"$f":"IF('Accounting 1 '!F26=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G26=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H26=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L26=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M26=\"Completed \",1.5,0)","v":0}]
[null,"AMALGAMATION, CONVERSION AND SALE OF PARTNERSHIP FIRMS ",null,{"$f":"IF('Accounting 1 '!F27=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!G27=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!H27=\"Completed \",1.5,0)","v":0},null,null,null,{"$f":"IF('Accounting 1 '!L27=\"Completed \",1.5,0)","v":0},{"$f":"IF('Accounting 1 '!M27=\"Completed \",1.5,0)","v":0},{"$nulls":5},{"$f":"30*40000","v":1200000}]
[]
[]
[null,null,null,{"$f":"SUM(D3:D32)","v":0},{"$f":"SUM(E3:E32)","v":0},0,{"$f":"SUM(G3)","v":0},{"$f":"SUM(H3)","v":0},0,0,0,null,270]
[null,null,null,{"$f":"D33*1","v":0},{"$f":"E33*1","v":0},0,{"$f":"G33/2","v":0},{"$f":"H33/2","v":0},0,0,0,{"$f":"SUM(D34:K34)","v":0},{"$f":"L34/M33","v":0}]
[null,null,null,"Weightage"]
[]
[]
[]
[null,"Cost and Management Accounting ",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap","Taxation",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,null,null,{"$f":"IF(Costing!F2=\"Completed \",1,0)","v":1},{"$f":"IF(Costing!G2=\"Completed \",1,0)","v":1},{"$f":"IF(Costing!H2=\"Completed \",1,0)","v":1},{"$f":"Costing!I17","v":45},{"$f":"Costing!J17","v":0},{"$f":"Costing!K17","v":0},{"$f":"IF(Costing!L2=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M2=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F2=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G2=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H2=\"Completed \",1,0)","v":0},{"$f":"'Taxation '!I24","v":0},{"$f":"'Taxation '!J24","v":0},{"$f":"'Taxation '!K24","v":0},{"$f":"IF('Taxation '!L2=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M2=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F3=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G3=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L3=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M3=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F3=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G3=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L3=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M3=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F4=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G4=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L4=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M4=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F4=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G4=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L4=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M4=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F5=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G5=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L5=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M5=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F5=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G5=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L5=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M5=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F6=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G6=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L6=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M6=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F6=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G6=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L6=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M6=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F7=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G7=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L7=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M7=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F7=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G7=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L7=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M7=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F8=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G8=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L8=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M8=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F8=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G8=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L8=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M8=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F9=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G9=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L9=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M9=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F9=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G9=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L9=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M9=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F10=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G10=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L10=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M10=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F10=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G10=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L10=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M10=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F11=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G11=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L11=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M11=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F11=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G11=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L11=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M11=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F12=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G12=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L12=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M12=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F12=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G12=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L12=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M12=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F13=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G13=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L13=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M13=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F13=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G13=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L13=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M13=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F14=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G14=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L14=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M14=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F14=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G14=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L14=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M14=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F15=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G15=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L15=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M15=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F15=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G15=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L15=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M15=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF(Costing!F16=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!G16=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!H16=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF(Costing!L16=\"Completed \",1,0)","v":0},{"$f":"IF(Costing!M16=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Taxation '!F16=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G16=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H16=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L16=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M16=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"SUM(D40:D54)","v":1},{"$f":"SUM(E40:E54)","v":1},1,45,0,0,0,0,null,225,{"$f":"IF('Taxation '!F17=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G17=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H17=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L17=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M17=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"D55","v":1},{"$f":"E55","v":1},1,{"$f":"G55/2","v":22.5},{"$f":"H55/2","v":0},{"$f":"I55/2","v":0},0,0,{"$f":"SUM(D56:K56)","v":25.5},{"$f":"L56/M55","v":0.11333333333333333},{"$f":"IF('Taxation '!F18=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G18=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H18=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L18=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M18=\"Completed \",1,0)","v":0}]
[null,null,null,"Weightage",{"$nulls":9},{"$f":"IF('Taxation '!F19=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G19=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H19=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L19=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M19=\"Completed \",1,0)","v":0}]
[{"$nulls":13},{"$f":"IF('Taxation '!F20=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G20=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H20=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L20=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M20=\"Completed \",1,0)","v":0}]
[{"$nulls":13},{"$f":"IF('Taxation '!F21=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G21=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H21=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L21=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M21=\"Completed \",1,0)","v":0}]
[{"$nulls":13},{"$f":"IF('Taxation '!F22=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!G22=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!H22=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Taxation '!L22=\"Completed \",1,0)","v":0},{"$f":"IF('Taxation '!M22=\"Completed \",1,0)","v":0}]
[{"$nulls":13},{"$f":"SUM(N31:N60)","v":0},{"$f":"SUM(O31:O60)","v":0},{"$f":"SUM(P31:P60)","v":0},{"$f":"SUM(Q31:Q60)","v":0},{"$f":"SUM(R31:R60)","v":0},{"$f":"SUM(S31:S60)","v":0},{"$f":"SUM(T31:T60)","v":0},{"$f":"SUM(U31:U60)","v":0},null,255]
[{"$nulls":13},{"$f":"N61","v":0},{"$f":"O61","v":0},0,{"$f":"Q61/2","v":0},{"$f":"R61/2","v":0},0,0,0,{"$f":"SUM(N62:U62)","v":0},{"$f":"V62/W61","v":0}]
[{"$nulls":13},"Weightage"]
[]
[null,"Accounting 2 ",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap","Auditing ",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,null,null,{"$f":"IF('Accounting 2 '!F2=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G2=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H2=\"Completed \",1,0)","v":0},{"$f":"'Accounting 2 '!I24","v":0},{"$f":"'Accounting 2 '!J24","v":0},{"$f":"'Accounting 2 '!K24","v":0},{"$f":"IF('Accounting 2 '!L2=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M2=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F2=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G2=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H2=\"Completed \",1,0)","v":0},{"$f":"'Auditing '!I16","v":0},{"$f":"'Auditing '!J16","v":0},{"$f":"'Auditing '!K16","v":0},{"$f":"IF('Auditing '!L2=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M2=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L3=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M3=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F3=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G3=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L3=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M3=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L4=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M4=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F4=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G4=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L4=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M4=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F5=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G5=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L5=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M5=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F5=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G5=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L5=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M5=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F6=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G6=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L6=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M6=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F6=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G6=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L6=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M6=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F7=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G7=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L7=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M7=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F7=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G7=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L7=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M7=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F8=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G8=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L8=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M8=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F8=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G8=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L8=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M8=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F9=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G9=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L9=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M9=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F9=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G9=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L9=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M9=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F10=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G10=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L10=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M10=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F10=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G10=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L10=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M10=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F11=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G11=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L11=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M11=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F11=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G11=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L11=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M11=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F12=\"Completed \",1,0)","v":1},{"$f":"IF('Accounting 2 '!G12=\"Completed \",1,0)","v":1},{"$f":"IF('Accounting 2 '!H12=\"Completed \",1,0)","v":1},null,null,null,{"$f":"IF('Accounting 2 '!L12=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M12=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F12=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G12=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L12=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M12=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F13=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G13=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L13=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M13=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F13=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G13=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L13=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M13=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L14=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M14=\"Completed \",1,0)","v":0},null,null,{"$f":"IF('Auditing '!F14=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!G14=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Auditing '!L14=\"Completed \",1,0)","v":0},{"$f":"IF('Auditing '!M14=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L15=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M15=\"Completed \",1,0)","v":0},null,null,{"$f":"SUM(N66:N78)","v":0},0,0,0,0,0,0,0,null,215]
[null,null,null,{"$f":"IF('Accounting 2 '!F16=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G16=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H16=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L16=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M16=\"Completed \",1,0)","v":0},null,null,{"$f":"N79","v":0},{"$f":"O79","v":0},0,{"$f":"Q79/2","v":0},{"$f":"R79/2","v":0},{"$f":"S79/2","v":0},0,0,{"$f":"SUM(N80:U80)","v":0},{"$f":"V80/W79","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H17=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L17=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M17=\"Completed \",1,0)","v":0},null,null,"Weightage"]
[null,null,null,{"$f":"IF('Accounting 2 '!F18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H18=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L18=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M18=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F19=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G19=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H19=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L19=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M19=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H20=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L20=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M20=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H21=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L21=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M21=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F22=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G22=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H22=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L22=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M22=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('Accounting 2 '!F23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!G23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!H23=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('Accounting 2 '!L23=\"Completed \",1,0)","v":0},{"$f":"IF('Accounting 2 '!M23=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"SUM(D66:D87)","v":1},{"$f":"SUM(E66:E87)","v":1},1,0,0,0,0,0,null,260]
[null,null,null,{"$f":"D88","v":1},{"$f":"E88","v":1},1,{"$f":"G88/2","v":0},{"$f":"H88/2","v":0},0,0,0,{"$f":"SUM(D89:K89)","v":3},{"$f":"L89/M88","v":1.1538461538461539E-2}]
[null,null,null,"Weightage"]
[]
[]
[]
[null,"IT and SM",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap",null,null,"FM",null,"Theory ","Study Material ","Practice Manual / Revision Test Papers","Mock Exam 1 ","Mock Exam 2","Mock Exam 3","Revision ","Recap"]
[null,null,null,{"$f":"IF('IT & SM'!F2=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G2=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H2=\"Completed \",1,0)","v":0},{"$f":"'IT & SM'!I16","v":0},{"$f":"'IT & SM'!J16","v":0},{"$f":"'IT & SM'!K16","v":0},{"$f":"IF('IT & SM'!L2=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M2=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F2=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G2=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H2=\"Completed \",1,0)","v":0},{"$f":"'FM '!I17","v":0},{"$f":"'FM '!J17","v":0},{"$f":"'FM '!K17","v":0},{"$f":"IF('FM '!L2=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M2=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F3=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G3=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L3=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M3=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F3=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G3=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H3=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L3=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M3=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F4=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G4=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L4=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M4=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F4=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G4=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H4=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L4=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M4=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F5=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G5=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L5=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M5=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F5=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G5=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H5=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L5=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M5=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F6=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G6=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L6=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M6=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F6=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G6=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H6=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L6=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M6=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F7=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G7=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L7=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M7=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F7=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G7=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H7=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L7=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M7=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F8=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G8=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L8=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M8=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F8=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G8=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H8=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L8=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M8=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F9=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G9=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L9=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M9=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F9=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G9=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H9=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L9=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M9=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F10=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G10=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L10=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M10=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F10=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G10=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H10=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L10=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M10=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F11=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G11=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L11=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M11=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F11=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G11=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H11=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L11=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M11=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F12=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G12=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L12=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M12=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F12=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G12=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H12=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L12=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M12=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F13=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G13=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L13=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M13=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F13=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G13=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H13=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L13=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M13=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"IF('IT & SM'!F14=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!G14=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('IT & SM'!L14=\"Completed \",1,0)","v":0},{"$f":"IF('IT & SM'!M14=\"Completed \",1,0)","v":0},{"$nulls":4},{"$f":"IF('FM '!F14=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G14=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H14=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L14=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M14=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"SUM(D95:D107)","v":0},{"$f":"SUM(E95:E107)","v":0},0,0,0,0,0,0,null,215,null,null,{"$f":"IF('FM '!F15=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G15=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H15=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L15=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M15=\"Completed \",1,0)","v":0}]
[null,null,null,{"$f":"D108","v":0},{"$f":"E108","v":0},0,{"$f":"G108/2","v":0},{"$f":"H108/2","v":0},0,0,0,{"$f":"SUM(D109:K109)","v":0},{"$f":"L109/M108","v":0},null,null,{"$f":"IF('FM '!F16=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!G16=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!H16=\"Completed \",1,0)","v":0},null,null,null,{"$f":"IF('FM '!L16=\"Completed \",1,0)","v":0},{"$f":"IF('FM '!M16=\"Completed \",1,0)","v":0}]
[null,null,null,"Weightage",{"$nulls":11},{"$f":"SUM(P95:P109)","v":0},{"$f":"SUM(Q95:Q109)","v":0},0,0,0,0,0,0,null,225]
[{"$nulls":15},{"$f":"P110","v":0},{"$f":"Q110","v":0},0,{"$f":"S110/2","v":0},{"$f":"T110/2","v":0},0,0,0,{"$f":"SUM(P111:W111)","v":0},{"$f":"X111/Y110","v":0}]
[{"$nulls":15},"Weightage"]